<%@ page contentType="text/html; charset=UTF-8" import="com.pub.database.*,com.pub.database.oracle.*,java.util.*,oracle.jdbc.OracleTypes,java.sql.*"%>
<%
  //String[] strFlowNum={String.valueOf(OracleTypes.CURSOR)};
  String[] strFlowNum={"06066",String.valueOf(java.sql.Types.VARCHAR),String.valueOf(java.sql.Types.VARCHAR),String.valueOf(java.sql.Types.VARCHAR)};
  QueryBean qbnDAO = null;
  ArrayList altResult=null;
  ResultSet rs=null;
  //CallableStatement aCallStmt = null;

  try{
    qbnDAO=new QueryBean("PIS1_WFLOW",
    true, "BIG5", "BIG5");

    altResult=(new OracleFunction()).runStoredProcedure(qbnDAO.getConnection(),"DG_SP_CHECK_DAYS(in,out,out,out)",strFlowNum);
    /*aCallStmt = qbnDAO.getConnection().prepareCall("{?=call DG_CHECK_DAYS_TEST}");

    aCallStmt.registerOutParameter(1,OracleTypes.CURSOR);

    aCallStmt.execute();

    rs=(ResultSet)aCallStmt.getObject(1);

    while(rs.next()){
      System.out.println(rs.getInt(3));
    }*/

  }
  catch(Exception e){
    e.printStackTrace();
  }
  finally{
    try{qbnDAO.close();}catch(Exception e){e.printStackTrace();}
    //try{aCallStmt.close();}catch(Exception e){e.printStackTrace();}
  }
%>
